package com.device.search.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.device.search.model.DeviceInit;


public interface ConstructionBasicMapper {

	@Select("SELECT d.construction_id,d.id,b.project_name,d.dvice_no,d.pid,s.mobile FROM construction_basic b LEFT JOIN construction_device d ON b.id=d.construction_id LEFT JOIN construction_contacts s ON b.id=s.construction_id \r\n" + 
			"WHERE b.id=d.construction_id AND d.pid=0 AND d.construction_id NOT IN(2,58) ORDER BY d.construction_id ASC")
	List<DeviceInit> findDeviceStatus();

}
